package cn.neusoft.edu.his.demo.mapper;

import cn.neusoft.edu.his.demo.po.Registration;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
@Mapper
public interface RegistrationMapper extends BaseMapper<Registration> {
    @Select("select t.*,c.*,f.* from doctor_work t,doctor c,doctorfee f where t.doc_id=c.doc_id AND f.fee_id=t.fee_id AND t.day=#{day} AND c.depart_id2=#{departId2}")
    List<Registration> getRegistration(Registration registration);

    @Select("select t.*,c.* from doctor_work t,doctor c where t.doc_id=c.doc_id AND c.doc_id=#{doc_id}")
    List<Registration> getRegistrationDoc(Registration registration);

}